clear
*cd $data 
cd "C:\Users\JGW99\Dropbox\Forest\Data"

use CEE_Data\ParcelLevelDataSept282023_VerNov82024_R1

*Checking difference with original parcel level data
/*
gen groupR1=group
merge 1:1 taxidnum fips year using ParcelLevelDataSept282023_VerNov82024, gen(merge) keepusing(fips group)
drop if forestAcres<1
tab merge if year==2019
tab groupR1 if year==2019
tab group if year==2019
br if merge!=3 & year==2019
*/

*Requiring parcels to have at least one acre of forest
	drop if forestAcres<1
	tab group if year==2019

*Focusing on pre enrollment years (pre-2020)
drop if year>2019

*owner-level participation variable
bysort owner_key year: egen ienrolled_bar=mean(ienrolled)
gen ienrolled_owner=(ienrolled_bar>0)

*****************************************************
*Statistics for owners who did not enroll all parcels

*Mean harvesting on ENROLLED PARCELS among owners who did not enroll all parcels
mean Landtr_Cut_mean_forest8599 Landtr_Cut_mean_forest0014 Landtr_Cut_mean_forest1519 if ienrolled==1 & ienrolled_bar<1 & year==2019

*Mean harvesting on NOT ENROLLED PARCELS among owners who did not enroll all parcels
mean Landtr_Cut_mean_forest8599 Landtr_Cut_mean_forest0014 Landtr_Cut_mean_forest1519 if ienrolled==0 & ienrolled_owner==1 & year==2019
**************************************************************

